<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
	<title>SQL access | ElasticSearch 7.7 权威指南中文版</title>
	<meta name="keywords" content="ElasticSearch 权威指南中文版, elasticsearch 7, es7, 实时数据分析，实时数据检索" />
    <meta name="description" content="ElasticSearch 权威指南中文版, elasticsearch 7, es7, 实时数据分析，实时数据检索" />
    <!-- Give IE8 a fighting chance -->
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
	<link rel="stylesheet" type="text/css" href="../static/styles.css" />
	<script>
	var _link = 'xpack-sql.html';
    </script>
</head>
<body>
<div class="main-container">
    <section id="content">
        <div class="content-wrapper">
            <section id="guide" lang="zh_cn">
                <div class="container">
                    <div class="row">
                        <div class="col-xs-12 col-sm-8 col-md-8 guide-section">
                            <div style="color:gray; word-break: break-all; font-size:12px;">原英文版地址: <a href="https://www.elastic.co/guide/en/elasticsearch/reference/7.7/xpack-sql.html" rel="nofollow" target="_blank">https://www.elastic.co/guide/en/elasticsearch/reference/7.7/xpack-sql.html</a>, 原文档版权归 www.elastic.co 所有<br/>本地英文版地址: <a href="../en/xpack-sql.html" rel="nofollow" target="_blank">../en/xpack-sql.html</a></div>
                        <!-- start body -->
                  <div class="page_header">
<strong>重要</strong>: 此版本不会发布额外的bug修复或文档更新。最新信息请参考 <a href="https://www.elastic.co/guide/en/elasticsearch/reference/current/index.html" rel="nofollow">当前版本文档</a>。
</div>
<div id="content">
<div class="breadcrumbs">
<span class="breadcrumb-link"><a href="index.html">Elasticsearch Guide [7.7]</a></span>
»
<span class="breadcrumb-node">SQL access</span>
</div>
<div class="navheader">
<span class="prev">
<a href="regexp-syntax.html">« Regular expression syntax</a>
</span>
<span class="next">
<a href="sql-overview.html">Overview »</a>
</span>
</div>
<div class="part xpack">
<div class="titlepage"><div><div>
<h1 class="title">
<a id="xpack-sql"></a>SQL access<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/index.asciidoc">edit</a><a class="xpack_tag" href="https://www.elastic.co/subscriptions"></a>
</h1>
</div></div></div>
<div class="openblock partintro">
<div class="content">
<p>X-Pack includes a SQL feature to execute SQL queries against Elasticsearch
indices and return results in tabular format.</p>
<p>The following chapters aim to cover everything from usage, to syntax and drivers.
Experience users or those in a hurry might want to jump directly to
the list of SQL <a class="xref" href="sql-commands.html" title="SQL Commands">commands</a> and <a class="xref" href="sql-functions.html" title="Functions and Operators">functions</a>.</p>
<div class="variablelist">
<dl class="variablelist">
<dt>
<span class="term">
<a class="xref" href="sql-overview.html" title="Overview">Overview</a>
</span>
</dt>
<dd>
Overview of Elasticsearch SQL and its features.
</dd>
<dt>
<span class="term">
<a class="xref" href="sql-getting-started.html" title="Getting Started with SQL">Getting Started</a>
</span>
</dt>
<dd>
Start using SQL right away in Elasticsearch.
</dd>
<dt>
<span class="term">
<a class="xref" href="sql-concepts.html" title="Conventions and Terminology">Concepts and Terminology</a>
</span>
</dt>
<dd>
Language conventions across SQL and Elasticsearch.
</dd>
<dt>
<span class="term">
<a class="xref" href="sql-security.html" title="Security">Security</a>
</span>
</dt>
<dd>
Secure Elasticsearch SQL and Elasticsearch.
</dd>
<dt>
<span class="term">
<a class="xref" href="sql-rest.html" title="SQL REST API">REST API</a>
</span>
</dt>
<dd>
Execute SQL in JSON format over REST.
</dd>
<dt>
<span class="term">
<a class="xref" href="sql-translate.html" title="SQL Translate API">Translate API</a>
</span>
</dt>
<dd>
Translate SQL in JSON format to Elasticsearch native query.
</dd>
<dt>
<span class="term">
<a class="xref" href="sql-cli.html" title="SQL CLI">CLI</a>
</span>
</dt>
<dd>
Command-line application for executing SQL against Elasticsearch.
</dd>
<dt>
<span class="term">
<a class="xref" href="sql-jdbc.html" title="SQL JDBC">JDBC</a>
</span>
</dt>
<dd>
JDBC driver for Elasticsearch.
</dd>
<dt>
<span class="term">
<a class="xref" href="sql-odbc.html" title="SQL ODBC">ODBC</a>
</span>
</dt>
<dd>
ODBC driver for Elasticsearch.
</dd>
<dt>
<span class="term">
<a class="xref" href="sql-client-apps.html" title="SQL Client Applications">Client Applications</a>
</span>
</dt>
<dd>
Setup various SQL/BI tools with Elasticsearch SQL.
</dd>
<dt>
<span class="term">
<a class="xref" href="sql-spec.html" title="SQL Language">SQL Language</a>
</span>
</dt>
<dd>
Overview of the Elasticsearch SQL language, such as supported data types, commands and
syntax.
</dd>
<dt>
<span class="term">
<a class="xref" href="sql-functions.html" title="Functions and Operators">Functions and Operators</a>
</span>
</dt>
<dd>
List of functions and operators supported.
</dd>
<dt>
<span class="term">
<a class="xref" href="sql-limitations.html" title="SQL Limitations">Limitations</a>
</span>
</dt>
<dd>
Elasticsearch SQL current limitations.
</dd>
</dl>
</div>
</div>
</div>














</div>
<div class="navfooter">
<span class="prev">
<a href="regexp-syntax.html">« Regular expression syntax</a>
</span>
<span class="next">
<a href="sql-overview.html">Overview »</a>
</span>
</div>
</div>

                  <!-- end body -->
                        </div>
                        <div class="col-xs-12 col-sm-4 col-md-4" id="right_col">
                        
                        </div>
                    </div>
                </div>
            </section>
        </div>
    </section>
</div>
<script src="../static/cn.js"></script>
</body>
</html>